USE SAS
GO

 
  IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'GetStatesData')
	BEGIN
		DROP  Procedure  dbo.GetStatesData
	END

GO

CREATE Procedure dbo.GetStatesData
AS
BEGIN
	select * FROM dbo.TR_STATES  
	ORDER BY  StateDesc 
END
GO
